package com.sh.ndt.common;

/**
 * Interface to hold constant definitions related to Trax app's databases
 *
 * @author Prashanth NC
 */
public interface DBConstants {

    static final String CONFIG_DB = "configdb.";
    static final String REF_DB = "refdb.";
    static final String TRAX_DB = "traxdb.";
    static final String DBO = "dbo.";
    // Login
    static final String SP_LOGIN = CONFIG_DB + DBO + "sp_Login";
    // Compensation
    //static final String SP_COMPENSATION = TRAX_DB + "manjula." + "sp_TWGetCompViewSummary";
    static final String SP_COMPENSATION = TRAX_DB + DBO + "sp_TWGetCompViewSummary";
    // App Cache
    static final String SP_APP_CACHELOAD = CONFIG_DB + DBO + "sp_AppCache_Load";
    // Acct Exec Lookup
    static final String SP_ACCEXEC_LOOKUP = CONFIG_DB + DBO + "sp_AccExec_LookUp";
    // Get Trade Details
    static final String SP_TRADE_DETAILS = TRAX_DB + DBO + "sp_tw_get_trade_details";
    // Misc Expense
    static final String SP_MISC_EXPENSE = TRAX_DB + DBO + "sp_rpt_Misc_Expense_For_Payout_Sheet";
    // Get Trade Account Summary
    static final String SP_TRADE_ACCT_SUMMARY = TRAX_DB + DBO + "sp_tw_get_trade_acct_summary";
    // Get Currency Rate
    static final String SP_CURRENCY_RATES = REF_DB + DBO + "sp_GetCurrencyRates";
    //Get customer by gross commission reports
    static final String SP_CUSTOMER_BY_GROSS_COMMISSION = TRAX_DB + DBO + "sp_rpt_Customer_By_GrossCommission";
    //Get top 25 customer by gross commission reports by Delta 
    static final String SP_CUSTOMER_BY_GROSS_COMMISSION_DELTA = TRAX_DB + DBO + "sp_rpt_Customer_By_GrossCommission_Delta";
    //Get customers by Daily,MTD,YTD and Gross Commission  
    static final String SP_CUSTOMER_BY_GROSS_COMMISSION_DAILY_MTD = TRAX_DB + DBO + "sp_rpt_GrossComm_PL";
    // Get gross comm by month (12 months previous)
    static final String SP_GROSS_COMMISSION_MONTH = TRAX_DB + DBO + "sp_rpt_Customer_GrossCommission_By_Month";
    // Get salesman payout by month (12 months previous)
    static final String SP_SALESMAN_PAYOUT = TRAX_DB + DBO + "sp_rpt_Salesman_Payouts_By_Month";
    // Get System properties list for Admin bean
    static final String SP_SYSTEMPROPERTIES_LIST = CONFIG_DB + DBO + "sp_SystemProperties_List";
    // Get Entitlement manager list for Admin bean
    static final String SP_ENTITLEMENTMANAGER_LIST = CONFIG_DB + DBO + "sp_Entitlement_Search";
    // Get Desk Manager List for Admin Bean 
    static final String SP_DESKMANAGER_LIST = CONFIG_DB + DBO + "sp_Desk_Load";
    // Get Report Manager List for Admin Bean
    static final String SP_REPORTMANAGER_LIST = CONFIG_DB + DBO + "sp_Reports_List";
    // Get Report Manager Load Lists for Filters 
    static final String SP_REPORTMANAGER_LOAD = CONFIG_DB + DBO + "sp_Report_Load";
    // Get Charge venue manager data list for admin bean
    static final String SP_CHARGE_VENUE_SEARCH = TRAX_DB + DBO + "sp_Charge_Venue_Search";
    // Get mail drafter details list for admin bean 
    static final String SP_MAIL_DRAFTER_DETAILS = CONFIG_DB + DBO + "sp_email_body_details_Load";
    // Get firm legal entity mngr list for admin bean
    static final String SP_FIRM_LEGAL_ENTITY_MNGR_LIST = REF_DB + DBO + "sp_FirmLegalEntity_Search";
    // Get Invoice Summary details
    static final String SP_GET_INVOICE_SUMMARY = TRAX_DB + DBO + "sp_GetInvoiceSummary";
    // Get Invoice revision List
    static final String SP_GET_INVOICE_REVISION = TRAX_DB + DBO + "sp_GetInvoiceSummary_Version";
    // Get user Entitlement load 
    static final String SP_ENTITLEMENT_LOAD = CONFIG_DB + DBO + "sp_Entitlement_Load";
    // Get Entitlement Search list
    static final String SP_ENTITLEMENT_SEARCH = CONFIG_DB + DBO + "sp_Entitlement_Search";
    // Get Entitlement Update list
    static final String SP_ENTITLEMENT_UPDATE = CONFIG_DB + DBO + "sp_Entitlement_Update";
    // Get Trade Blotter filter data
    public static String SP_TRADE_BLOTTER_LOOK_UP = REF_DB + DBO + "sp_TradeBlotterLookupLoad";
    // Get Standard Trade Blotter data
    public static String SP_GET_OPTION_TRADES = TRAX_DB + DBO + "sp_GetOptionTrades";
    // Get Trade Blotter Deals data
    public static String SP_ENVIRONMENT_TRADES_SEARCH = TRAX_DB + DBO + "sp_EnvironmentTrades_Search";
    // Get user's floor broker list for Options ticket entry floor broker filter
    public static String SP_FLOOR_BROKER_LIST_LOOKUP = TRAX_DB + DBO + "sp_floorbroker_list_lookup";
    // Get Short Name Data for Option ticket entry on selected short name
    public static String SP_GET_SHORTNAME_DATA = REF_DB + DBO + "sp_GetShortNameData";
    // Get clearence charge for Option Ticket Entry on selected exchange
    public static String SP_GET_CLEARANCE_CHARGE = TRAX_DB + DBO + "sp_get_clearance_charge";
    // Get floor broker charge for Option Ticket Entry on selected floor broker
    public static String SP_GET_FLOOR_BROKERAGE = TRAX_DB + DBO + "sp_get_floor_brokerage";
    // Get oms clearence charge for Option Ticket Entry on selected oms name
    public static String SP_GET_CLEARENCE_OMS_CHARGE = TRAX_DB + DBO + "sp_GetOptionClearanceOmsCharge";
    // Get buy side trader for Option Ticket Entry on selected short name  
    public static String SP_BUY_SIDE_TRADER = REF_DB + DBO + "sp_ShortName_BuySideTrader_List";
    // Get options series data for Option Ticket options Series table on Click of ticker 
    public static String MATCHED_CANDIDATE_OPTION_SERIES = REF_DB + DBO + "sp_GetMatchedCandidateOptionSeries";
    // Get shortName search data for new Short name page data table
    public static String SP_GET_SHORTNAME_SEARCH = REF_DB + DBO + "sp_ShortName_Search";
    // Get floor borker data list for floor broker maintaince page dataq table 
    public static String SP_FLOOR_BROKER_LIST = REF_DB + DBO + "sp_FloorBroker_List";
    
    
    
    //
    // SPs to operate on traxdb..t_inv_payments table
    //
    public static final String SP_PAYMENT_RECORD_ADD_EDIT = TRAX_DB + DBO + "sp_Check_AddEdit";
    public static final String SP_PAYMENT_RECORD_DELETE = TRAX_DB + DBO + "sp_Inv_Check_Delete";
    public static final String SP_PAYMENT_RECORD_QUERY = TRAX_DB + DBO + "sp_Get_Inv_CheckData";
    
    
    //
    // SPs to operate on the newly added table, traxdb..t_payments table
    //
    public static final String SP_PAYMENT_ADD_EDIT = TRAX_DB + DBO + "sp_Payment_AddEdit";
    public static final String SP_PAYMENT_DELETE = TRAX_DB + DBO + "sp_Payment_Delete";
    public static final String SP_GET_PAYMENTS = TRAX_DB + DBO + "sp_Get_Payments";    
}
